unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DBXpress, FMTBcd, Borland.Vcl.Db, Borland.Vcl.SqlExpr,
  System.ComponentModel, Borland.Vcl.StdCtrls, Borland.Vcl.Mask,
  Borland.Vcl.DBCtrls, Borland.Vcl.ExtCtrls, Borland.Vcl.Grids,
  Borland.Vcl.DBGrids, Borland.Vcl.Provider, Borland.Vcl.DBClient;

type
  TForm1 = class(TForm)
    DataSetProvider1: TDataSetProvider;
    GroupBox1: TGroupBox;
    Button1: TButton;
    Button2: TButton;
    GroupBox2: TGroupBox;
    Button3: TButton;
    Button4: TButton;
    GroupBox3: TGroupBox;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    SQLConnection1: TSQLConnection;
    ClientDataSet1: TClientDataSet;
    GroupBox4: TGroupBox;
    ComboBox1: TComboBox;
    Edit1: TEdit;
    SQLQuery1: TSQLQuery;
    Button9: TButton;
    procedure Button9Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Edit1MouseMove(Sender: TObject; Shift: TShiftState; X,
      Y: Integer);
    procedure Button6Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.nfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
     ClientDataSet1.Insert;
     Button1.Enabled := false;
     Button7.Enabled := true;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
    ClientDataSet1.Append;
    Button7.Enabled := true;
    Button2.Enabled := false;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
      ClientDataSet1.Post;
      Button4.Enabled := false;
      Button3.Enabled := true;
end;

procedure TForm1.Button7Click(Sender: TObject);
begin

    ClientDataSet1.Post;
    Button7.Enabled := false;

    Button1.Enabled := true;
    Button2.Enabled := true;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
    ClientDataSet1.Edit;
    Button3.Enabled := false;
    Button4.Enabled := true;

end;

procedure TForm1.Button5Click(Sender: TObject);
begin
    ClientDataSet1.Delete;
end;

procedure TForm1.Button6Click(Sender: TObject);
begin
    if MessageDlg('ȷҪɾе?',mtWarning, [mbYes,mbNo],0) = mrNo then exit;
    while not ClientDataSet1.Eof do  ClientDataSet1.Delete;
end;

procedure TForm1.Edit1MouseMove(Sender: TObject; Shift: TShiftState; X,
  Y: Integer);
begin
    Edit1.SelectAll;
end;

procedure TForm1.Button8Click(Sender: TObject);
var str:string;
    iFieldCount,i:integer;
begin

 









end;

procedure TForm1.FormCreate(Sender: TObject);
var str:string;
    iFieldCount,i:integer;
begin
  ComboBox1.ItemIndex := 0;
  iFieldCount := SQLQuery1.FieldCount;
  for i := 0 to iFieldCount-1 do
  begin
      str:= SQLQuery1.Fields[i].FieldName;
      ComboBox1.Items.Add(str);
  end;
end;

procedure TForm1.Button9Click(Sender: TObject);
var sqlStr:string;
begin
    if (Edit1.Text = 'ѯؼ') or (ComboBox1.Text ='ѡֶ') then
    begin
        ShowMessage('ѯؼʺֶ');
        exit;
    end;  
    sqlStr := 'select * from stu where '+ ComboBox1.Text +' = '''+Edit1.Text+'''';
    SqlQuery1.SQL.Text := sqlStr;
    SqlQuery1.Close;
    ClientDataSet1.Close;
    SqlQuery1.ExecSQL();   //ִвѯ
    SqlQuery1.Open;
    ClientDataSet1.Open;
    DBGrid1.Refresh;
end;

end.